Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	672
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	84.1 KiB
Average record size in memory	128.2 B

Variable types

Numeric	13
Categorical	3

Alerts

`시간당청색광량` has constant value "0"	Constant
`일간누적청색광량` has constant value "0"	Constant
`DAT` is highly overall correlated with `내부온도관측치` and 3 other fields	High correlation
`내부온도관측치` is highly overall correlated with `DAT` and 6 other fields	High correlation
`내부습도관측치` is highly overall correlated with `DAT` and 7 other fields	High correlation
`시간당분무량` is highly overall correlated with `obs_time` and 7 other fields	High correlation
`일간누적분무량` is highly overall correlated with `obs_time` and 9 other fields	High correlation
`시간당백색광량` is highly overall correlated with `obs_time` and 9 other fields	High correlation
`일간누적백색광량` is highly overall correlated with `obs_time` and 7 other fields	High correlation
`시간당적색광량` is highly overall correlated with `obs_time` and 9 other fields	High correlation
`일간누적적색광량` is highly overall correlated with `obs_time` and 7 other fields	High correlation
`시간당총광량` is highly overall correlated with `obs_time` and 9 other fields	High correlation
`일간누적총광량` is highly overall correlated with `obs_time` and 7 other fields	High correlation
`obs_time` is highly overall correlated with `내부습도관측치` and 8 other fields	High correlation
`co2관측치` is highly overall correlated with `DAT` and 1 other fields	High correlation
`ec관측치` is highly overall correlated with `DAT` and 3 other fields	High correlation
`obs_time` is uniformly distributed	Uniform
`DAT` has 24 (3.6%) zeros	Zeros
`ec관측치` has 25 (3.7%) zeros	Zeros
`시간당분무량` has 147 (21.9%) zeros	Zeros
`일간누적분무량` has 22 (3.3%) zeros	Zeros
`시간당백색광량` has 252 (37.5%) zeros	Zeros
`일간누적백색광량` has 168 (25.0%) zeros	Zeros
`시간당적색광량` has 252 (37.5%) zeros	Zeros
`일간누적적색광량` has 168 (25.0%) zeros	Zeros
`시간당총광량` has 252 (37.5%) zeros	Zeros
`일간누적총광량` has 168 (25.0%) zeros	Zeros

Reproduction

Analysis started	2022-11-23 12:43:36.897630
Analysis finished	2022-11-23 12:43:56.442183
Duration	19.54 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

DAT
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	28
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.5

Minimum	0
Maximum	27
Zeros	24
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	6.75
median	13.5
Q3	20.25
95-th percentile	26
Maximum	27
Range	27
Interquartile range (IQR)	13.5

Descriptive statistics

Standard deviation	8.0837642
Coefficient of variation (CV)	0.59879734
Kurtosis	-1.2030827
Mean	13.5
Median Absolute Deviation (MAD)	7
Skewness	0
Sum	9072
Variance	65.347243
Monotonicity	Increasing

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	24	3.6%
1	24	3.6%
26	24	3.6%
25	24	3.6%
24	24	3.6%
23	24	3.6%
22	24	3.6%
21	24	3.6%
20	24	3.6%
19	24	3.6%
Other values (18)	432	64.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	24	3.6%
1	24	3.6%
2	24	3.6%
3	24	3.6%
4	24	3.6%
5	24	3.6%
6	24	3.6%
7	24	3.6%
8	24	3.6%
9	24	3.6%

Value	Count	Frequency (%)
27	24	3.6%
26	24	3.6%
25	24	3.6%
24	24	3.6%
23	24	3.6%
22	24	3.6%
21	24	3.6%
20	24	3.6%
19	24	3.6%
18	24	3.6%

obs_time
Categorical

HIGH CORRELATION
UNIFORM

Distinct	24
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

00:00	28
01:00	28
22:00	28
21:00	28
20:00	28
Other values (19)	532

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	3360
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	00:00
2nd row	01:00
3rd row	02:00
4th row	03:00
5th row	04:00

Common Values

Value	Count	Frequency (%)
00:00	28	4.2%
01:00	28	4.2%
22:00	28	4.2%
21:00	28	4.2%
20:00	28	4.2%
19:00	28	4.2%
18:00	28	4.2%
17:00	28	4.2%
16:00	28	4.2%
15:00	28	4.2%
Other values (14)	392	58.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00	28	4.2%
01:00	28	4.2%
02:00	28	4.2%
03:00	28	4.2%
04:00	28	4.2%
05:00	28	4.2%
06:00	28	4.2%
07:00	28	4.2%
08:00	28	4.2%
09:00	28	4.2%
Other values (14)	392	58.3%

Most occurring characters

Value	Count	Frequency (%)
0	1708	50.8%
:	672	20.0%
1	364	10.8%
2	196	5.8%
3	84	2.5%
9	56	1.7%
8	56	1.7%
7	56	1.7%
6	56	1.7%
5	56	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2688	80.0%
Other Punctuation	672	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1708	63.5%
1	364	13.5%
2	196	7.3%
3	84	3.1%
9	56	2.1%
8	56	2.1%
7	56	2.1%
6	56	2.1%
5	56	2.1%
4	56	2.1%

Other Punctuation

Value	Count	Frequency (%)
:	672	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3360	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1708	50.8%
:	672	20.0%
1	364	10.8%
2	196	5.8%
3	84	2.5%
9	56	1.7%
8	56	1.7%
7	56	1.7%
6	56	1.7%
5	56	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3360	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1708	50.8%
:	672	20.0%
1	364	10.8%
2	196	5.8%
3	84	2.5%
9	56	1.7%
8	56	1.7%
7	56	1.7%
6	56	1.7%
5	56	1.7%

내부온도관측치
Real number (ℝ)

Distinct	590
Distinct (%)	87.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.621507

Minimum	25.081667
Maximum	30.918333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	25.081667
5-th percentile	25.200917
Q1	25.415833
median	26.088334
Q3	27.695
95-th percentile	29.168583
Maximum	30.918333
Range	5.8366664
Interquartile range (IQR)	2.279167

Descriptive statistics

Standard deviation	1.4165925
Coefficient of variation (CV)	0.053212335
Kurtosis	-0.41631349
Mean	26.621507
Median Absolute Deviation (MAD)	0.77250032
Skewness	0.87246989
Sum	17889.653
Variance	2.0067344
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.58333365	3	0.4%
25.61500044	3	0.4%
25.93666643	3	0.4%
26.10000038	3	0.4%
25.46166658	2	0.3%
27.46999989	2	0.3%
25.33166663	2	0.3%
25.40166661	2	0.3%
25.46271185	2	0.3%
25.47000001	2	0.3%
Other values (580)	648	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25.0816666	1	0.1%
25.09833333	1	0.1%
25.1016667	1	0.1%
25.12000008	1	0.1%
25.12241377	1	0.1%
25.12833325	1	0.1%
25.13000002	1	0.1%
25.13333321	1	0.1%
25.13666652	1	0.1%
25.14500052	1	0.1%

Value	Count	Frequency (%)
30.91833302	1	0.1%
30.87999954	1	0.1%
30.85999947	1	0.1%
30.69000018	1	0.1%
30.46999989	1	0.1%
30.29999943	1	0.1%
30.28166641	1	0.1%
30.21999985	1	0.1%
30.08333365	1	0.1%
30.07500029	1	0.1%

내부습도관측치
Real number (ℝ)

Distinct	608
Distinct (%)	90.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.17399

Minimum	74.201665
Maximum	85.366666
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	74.201665
5-th percentile	74.807583
Q1	76.733333
median	81.455
Q3	82.757084
95-th percentile	83.977833
Maximum	85.366666
Range	11.165002
Interquartile range (IQR)	6.0237508

Descriptive statistics

Standard deviation	3.1651345
Coefficient of variation (CV)	0.039478321
Kurtosis	-1.2165913
Mean	80.17399
Median Absolute Deviation (MAD)	1.8066668
Skewness	-0.53617118
Sum	53876.922
Variance	10.018077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81.67499987	4	0.6%
82.06166687	3	0.4%
81.30000051	2	0.3%
77.56166687	2	0.3%
75.9799998	2	0.3%
76.10666733	2	0.3%
82.44333318	2	0.3%
81.18666674	2	0.3%
80.90333354	2	0.3%
80.74166654	2	0.3%
Other values (598)	649	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
74.20166461	1	0.1%
74.20666491	1	0.1%
74.21166725	1	0.1%
74.21333377	1	0.1%
74.22333234	1	0.1%
74.23499959	1	0.1%
74.26833216	1	0.1%
74.28666751	1	0.1%
74.30666695	1	0.1%
74.33499997	1	0.1%

Value	Count	Frequency (%)
85.36666616	1	0.1%
84.8549998	1	0.1%
84.563333	1	0.1%
84.55333303	1	0.1%
84.4766669	1	0.1%
84.46500028	1	0.1%
84.42833341	1	0.1%
84.3766669	1	0.1%
84.36333377	1	0.1%
84.29666723	1	0.1%

co2관측치
Real number (ℝ)

Distinct	595
Distinct (%)	88.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	583.11902

Minimum	464.43333
Maximum	1264.3667
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	464.43333
5-th percentile	490.8325
Q1	530.69608
median	556.23333
Q3	588.17083
95-th percentile	815.56833
Maximum	1264.3667
Range	799.93333
Interquartile range (IQR)	57.474755

Descriptive statistics

Standard deviation	108.55757
Coefficient of variation (CV)	0.18616709
Kurtosis	11.9311
Mean	583.11902
Median Absolute Deviation (MAD)	28.191667
Skewness	3.1230028
Sum	391855.98
Variance	11784.747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
524.9	4	0.6%
517.6666667	3	0.4%
558.7666667	2	0.3%
544.1333333	2	0.3%
559.7	2	0.3%
564.4333333	2	0.3%
565.3166667	2	0.3%
565.8833333	2	0.3%
568.4666667	2	0.3%
564.0833333	2	0.3%
Other values (585)	649	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
464.4333333	1	0.1%
465.3166667	1	0.1%
468.8166667	1	0.1%
472.1666667	1	0.1%
473.6333333	1	0.1%
474.2166667	1	0.1%
474.5166667	1	0.1%
475.5833333	1	0.1%
475.9666667	1	0.1%
476.6666667	1	0.1%

Value	Count	Frequency (%)
1264.366667	1	0.1%
1225.066667	1	0.1%
1220.583333	1	0.1%
1217.5	1	0.1%
1173.266667	1	0.1%
1077.85	1	0.1%
1068.566667	1	0.1%
1043.066667	1	0.1%
1015.65	1	0.1%
1013.566667	1	0.1%

ec관측치
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	589
Distinct (%)	87.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3582882

Minimum	0
Maximum	1.6863771
Zeros	25
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.38034774
Q1	1.3987941
median	1.4293951
Q3	1.4427631
95-th percentile	1.598219
Maximum	1.6863771
Range	1.6863771
Interquartile range (IQR)	0.043969004

Descriptive statistics

Standard deviation	0.32515905
Coefficient of variation (CV)	0.23938884
Kurtosis	11.727682
Mean	1.3582882
Median Absolute Deviation (MAD)	0.022127035
Skewness	-3.5512698
Sum	912.7697
Variance	0.10572841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25	3.7%
1.396299801	3	0.4%
1.4097742	2	0.3%
1.393881486	2	0.3%
1.41359761	2	0.3%
1.413420808	2	0.3%
1.413755387	2	0.3%
1.407417979	2	0.3%
1.40673272	2	0.3%
1.395641418	2	0.3%
Other values (579)	628	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25	3.7%
0.000810324	1	0.1%
0.012939885	1	0.1%
0.01885271	1	0.1%
0.039426017	1	0.1%
0.088223923	1	0.1%
0.151125212	1	0.1%
0.214836823	1	0.1%
0.283790213	1	0.1%
0.34174094	1	0.1%

Value	Count	Frequency (%)
1.68637706	1	0.1%
1.685202825	1	0.1%
1.684601037	1	0.1%
1.683984536	1	0.1%
1.68320662	1	0.1%
1.683191933	1	0.1%
1.682487402	1	0.1%
1.68223786	1	0.1%
1.678039996	1	0.1%
1.677085904	1	0.1%

시간당분무량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	32
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	166.63129

Minimum	0
Maximum	252
Zeros	147
Zeros (%)	21.9%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	119.57
median	245.57
Q3	252
95-th percentile	252
Maximum	252
Range	252
Interquartile range (IQR)	132.43

Descriptive statistics

Standard deviation	101.00183
Coefficient of variation (CV)	0.60613963
Kurtosis	-1.1227612
Mean	166.63129
Median Absolute Deviation (MAD)	6.43
Skewness	-0.70516924
Sum	111976.23
Variance	10201.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
252	187	27.8%
0	147	21.9%
126	108	16.1%
245.57	51	7.6%
245.57	50	7.4%
245.57	27	4.0%
245.57	15	2.2%
119.57	14	2.1%
119.57	12	1.8%
252	6	0.9%
Other values (22)	55	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	147	21.9%
74.56	1	0.1%
119.57	5	0.7%
119.57	1	0.1%
119.57	14	2.1%
119.57	12	1.8%
119.57	1	0.1%
126	108	16.1%
126	2	0.3%
155.55	1	0.1%

Value	Count	Frequency (%)
252	2	0.3%
252	6	0.9%
252	5	0.7%
252	187	27.8%
252	4	0.6%
252	3	0.4%
245.57	50	7.4%
245.57	15	2.2%
245.57	51	7.6%
245.57	27	4.0%

일간누적분무량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	241
Distinct (%)	35.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1967.4066

Minimum	0
Maximum	4125.85
Zeros	22
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	119.57
Q1	462.855
median	1877.14
Q3	3376.28
95-th percentile	3974.13
Maximum	4125.85
Range	4125.85
Interquartile range (IQR)	2913.425

Descriptive statistics

Standard deviation	1416.5961
Coefficient of variation (CV)	0.72003221
Kurtosis	-1.4988382
Mean	1967.4066
Median Absolute Deviation (MAD)	1499.14
Skewness	0.059602152
Sum	1322097.2
Variance	2006744.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126	44	6.5%
252	38	5.7%
0	22	3.3%
378	16	2.4%
245.57	16	2.4%
119.57	14	2.1%
371.57	12	1.8%
623.57	10	1.5%
869.14	8	1.2%
3696.41	7	1.0%
Other values (231)	485	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	3.3%
119.57	14	2.1%
126	44	6.5%
239.14	2	0.3%
245.57	16	2.4%
252	38	5.7%
326.56	2	0.3%
365.14	2	0.3%
371.57	12	1.8%
378	16	2.4%

Value	Count	Frequency (%)
4125.85	2	0.3%
4119.42	1	0.1%
4106.56	2	0.3%
4093.7	1	0.1%
4074.41	2	0.3%
4048.69	2	0.3%
4035.83	2	0.3%
4029.4	2	0.3%
4012.71	2	0.3%
3999.85	3	0.4%

시간당백색광량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	41
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10648.69

Minimum	0
Maximum	18564.6
Zeros	252
Zeros (%)	37.5%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	18255.19
Q3	18255.19
95-th percentile	18255.19
Maximum	18564.6
Range	18564.6
Interquartile range (IQR)	18255.19

Descriptive statistics

Standard deviation	8939.2449
Coefficient of variation (CV)	0.83946894
Kurtosis	-1.8882376
Mean	10648.69
Median Absolute Deviation (MAD)	3.092282 × 10^-11
Skewness	-0.33893663
Sum	7155920
Variance	79910099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
18255.19	286	42.6%
0	252	37.5%
18255.19	22	3.3%
18255.19	18	2.7%
17945.78	16	2.4%
18255.19	10	1.5%
18255.19	9	1.3%
928.23	8	1.2%
17636.37	5	0.7%
618.82	4	0.6%
Other values (31)	42	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	252	37.5%
309.41	1	0.1%
485.7737	1	0.1%
513.6206	2	0.3%
550.7498	1	0.1%
618.82	4	0.6%
724.0194	1	0.1%
894.1949	1	0.1%
928.23	4	0.6%
928.23	8	1.2%

Value	Count	Frequency (%)
18564.6	3	0.4%
18564.6	1	0.1%
18255.19	9	1.3%
18255.19	1	0.1%
18255.19	286	42.6%
18255.19	10	1.5%
18255.19	22	3.3%
18255.19	18	2.7%
17945.78	1	0.1%
17945.78	16	2.4%

일간누적백색광량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	258
Distinct (%)	38.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122001.38

Minimum	0
Maximum	256324.53
Zeros	168
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	12763.162
median	117885.21
Q3	223027.37
95-th percentile	255708.8
Maximum	256324.53
Range	256324.53
Interquartile range (IQR)	210264.21

Descriptive statistics

Standard deviation	99907.825
Coefficient of variation (CV)	0.81890736
Kurtosis	-1.5655672
Mean	122001.38
Median Absolute Deviation (MAD)	109376.43
Skewness	0.079195764
Sum	81984925
Variance	9.9815735 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	168	25.0%
254953.84	13	1.9%
255572.66	12	1.8%
255263.25	10	1.5%
256324.5263	8	1.2%
255829.4703	8	1.2%
255467.4606	8	1.2%
127167.51	7	1.0%
163677.89	7	1.0%
181933.08	7	1.0%
Other values (248)	424	63.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	168	25.0%
17017.55	1	0.1%
17097.9966	1	0.1%
17240.3252	1	0.1%
17314.5836	1	0.1%
17326.96	4	0.6%
17376.4656	1	0.1%
17413.5948	1	0.1%
17422.8771	1	0.1%
17463.1004	1	0.1%

Value	Count	Frequency (%)
256324.5263	8	1.2%
256163.6331	4	0.6%
255829.4703	8	1.2%
255795.4352	4	0.6%
255767.5883	4	0.6%
255724.2709	4	0.6%
255708.8004	4	0.6%
255677.8594	4	0.6%
255597.4128	4	0.6%
255572.66	12	1.8%

시간당적색광량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	37
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	569.53685

Minimum	0
Maximum	992.88
Zeros	252
Zeros (%)	37.5%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	976.332
Q3	976.332
95-th percentile	976.332
Maximum	992.88
Range	992.88
Interquartile range (IQR)	976.332

Descriptive statistics

Standard deviation	478.06207
Coefficient of variation (CV)	0.83938742
Kurtosis	-1.8881904
Mean	569.53685
Median Absolute Deviation (MAD)	2.0463631 × 10^-12
Skewness	-0.3389416
Sum	382728.76
Variance	228543.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	252	37.5%
976.332	196	29.2%
976.332	77	11.5%
976.332	51	7.6%
976.332	21	3.1%
959.784	9	1.3%
959.784	9	1.3%
49.644	7	1.0%
33.096	6	0.9%
926.688	5	0.7%
Other values (27)	39	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	252	37.5%
21.5124	1	0.1%
26.4768	2	0.3%
33.096	6	0.9%
43.0248	2	0.3%
46.3344	2	0.3%
49.644	3	0.4%
49.644	7	1.0%
56.2632	2	0.3%
66.192	1	0.1%

Value	Count	Frequency (%)
992.88	2	0.3%
992.88	1	0.1%
992.88	1	0.1%
976.332	1	0.1%
976.332	196	29.2%
976.332	77	11.5%
976.332	51	7.6%
976.332	21	3.1%
959.784	9	1.3%
959.784	9	1.3%

일간누적적색광량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	251
Distinct (%)	37.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6524.9306

Minimum	0
Maximum	13708.363
Zeros	168
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	682.605
median	6303.9606
Q3	11927.798
95-th percentile	13675.267
Maximum	13708.363
Range	13708.363
Interquartile range (IQR)	11245.193

Descriptive statistics

Standard deviation	5343.406
Coefficient of variation (CV)	0.81892151
Kurtosis	-1.5655411
Mean	6524.9306
Median Absolute Deviation (MAD)	5849.718
Skewness	0.079244731
Sum	4384753.3
Variance	28551988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	168	25.0%
13662.0288	16	2.4%
13652.1	15	2.2%
13635.552	12	1.8%
13657.0644	8	1.2%
13708.3632	8	1.2%
13681.8864	8	1.2%
13668.648	8	1.2%
7761.012	6	0.9%
959.784	5	0.7%
Other values (241)	418	62.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	168	25.0%
910.14	1	0.1%
913.4496	1	0.1%
920.0688	1	0.1%
925.0332	1	0.1%
926.688	5	0.7%
928.3428	1	0.1%
929.9976	1	0.1%
931.6524	1	0.1%
934.962	1	0.1%

Value	Count	Frequency (%)
13708.3632	8	1.2%
13698.4344	4	0.6%
13696.7796	4	0.6%
13683.5412	4	0.6%
13681.8864	8	1.2%
13678.5768	4	0.6%
13675.2672	4	0.6%
13671.9576	4	0.6%
13670.3028	4	0.6%
13668.648	8	1.2%

시간당청색광량
Categorical

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

0	672

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	672
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	672	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	672	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	672	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	672	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	672	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	672	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	672	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	672	100.0%

일간누적청색광량
Categorical

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

0	672

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	672
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	672	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	672	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	672	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	672	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	672	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	672	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	672	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	672	100.0%

시간당총광량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	49
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11218.227

Minimum	0
Maximum	19557.48
Zeros	252
Zeros (%)	37.5%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	19231.522
Q3	19231.522
95-th percentile	19231.522
Maximum	19557.48
Range	19557.48
Interquartile range (IQR)	19231.522

Descriptive statistics

Standard deviation	9417.3029
Coefficient of variation (CV)	0.83946444
Kurtosis	-1.8882384
Mean	11218.227
Median Absolute Deviation (MAD)	5.4569682 × 10^-11
Skewness	-0.33893616
Sum	7538648.8
Variance	88685594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	252	37.5%
19231.522	196	29.2%
19231.522	40	6.0%
19231.522	33	4.9%
19231.522	31	4.6%
19231.522	27	4.0%
19231.522	14	2.1%
977.874	9	1.3%
18905.564	8	1.2%
19231.522	5	0.7%
Other values (39)	57	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	252	37.5%
342.506	1	0.1%
507.2861	1	0.1%
540.0974	2	0.3%
593.7746	1	0.1%
651.916	2	0.3%
651.916	2	0.3%
770.3538	1	0.1%
940.5293	1	0.1%
961.326	1	0.1%

Value	Count	Frequency (%)
19557.48	2	0.3%
19557.48	2	0.3%
19231.522	40	6.0%
19231.522	31	4.6%
19231.522	33	4.9%
19231.522	196	29.2%
19231.522	5	0.7%
19231.522	14	2.1%
19231.522	27	4.0%
18905.564	5	0.7%

일간누적총광량
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	287
Distinct (%)	42.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	128526.31

Minimum	0
Maximum	270032.89
Zeros	168
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	13445.767
median	124190
Q3	234955.17
95-th percentile	269380.76
Maximum	270032.89
Range	270032.89
Interquartile range (IQR)	221509.4

Descriptive statistics

Standard deviation	105251.23
Coefficient of variation (CV)	0.81890805
Kurtosis	-1.5655662
Mean	128526.31
Median Absolute Deviation (MAD)	115226.15
Skewness	0.0791981
Sum	86369678
Variance	1.1077821 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	168	25.0%
268915.35	10	1.5%
269511.3567	8	1.2%
268589.392	8	1.2%
269129.4894	8	1.2%
270032.8895	8	1.2%
269241.308	8	1.2%
210568.868	5	0.7%
268605.94	5	0.7%
229800.39	5	0.7%
Other values (277)	439	65.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	168	25.0%
17927.69	1	0.1%
18011.4462	1	0.1%
18160.394	1	0.1%
18239.6168	1	0.1%
18253.648	4	0.6%
18321.3564	1	0.1%
18341.9376	1	0.1%
18362.8035	1	0.1%
18393.098	1	0.1%

Value	Count	Frequency (%)
270032.8895	8	1.2%
269860.4127	4	0.6%
269511.3567	8	1.2%
269457.464	4	0.6%
269431.2719	4	0.6%
269399.5381	4	0.6%
269380.758	4	0.6%
269376.2938	4	0.6%
269264.406	4	0.6%
269243.8248	4	0.6%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	obs_time	내부온도관측치	내부습도관측치	co2관측치	ec관측치	시간당분무량	일간누적분무량	시간당백색광량	일간누적백색광량	시간당적색광량	일간누적적색광량	시간당총광량	일간누적총광량
0	00:00	25.300000	81.835000	536.016667	1.407439	0.00	0.00	0.00	0.00	0.000	0.000	0.000	0.000
1	01:00	25.680357	81.264286	528.696429	1.409003	126.00	126.00	0.00	0.00	0.000	0.000	0.000	0.000
2	02:00	25.273333	81.471666	532.833333	1.406913	0.00	126.00	0.00	0.00	0.000	0.000	0.000	0.000
3	03:00	25.355000	81.398334	545.566667	1.406689	126.00	252.00	0.00	0.00	0.000	0.000	0.000	0.000
4	04:00	25.391667	81.483333	558.583333	1.411070	0.00	252.00	0.00	0.00	0.000	0.000	0.000	0.000
5	05:00	25.375000	81.506666	571.483333	1.409658	119.57	371.57	0.00	0.00	0.000	0.000	0.000	0.000
6	06:00	26.436667	76.570000	575.083333	1.404834	252.00	623.57	17636.37	17636.37	959.784	959.784	18596.154	18596.154
7	07:00	26.960000	75.783334	574.550000	1.400731	239.14	862.71	18255.19	35891.56	976.332	1936.116	19231.522	37827.676
8	08:00	27.128334	75.568333	570.500000	1.398819	245.57	1108.28	18255.19	54146.75	976.332	2912.448	19231.522	57059.198
9	09:00	27.366666	75.541666	568.100000	1.396300	252.00	1360.28	18255.19	72401.94	976.332	3888.780	19231.522	76290.720

	DAT	obs_time	내부온도관측치	내부습도관측치	co2관측치	시간당분무량	일간누적분무량	시간당백색광량	일간누적백색광량	시간당적색광량	일간누적적색광량	시간당총광량	일간누적총광량
662	27	14:00	30.281666	83.190000	495.500000	252.00	2391.40	18255.19	163368.48	976.332	8737.344	19231.522	172105.824
663	27	15:00	30.470000	82.856667	485.633333	252.00	2643.40	18255.19	181623.67	976.332	9713.676	19231.522	191337.346
664	27	16:00	30.690000	83.160000	477.566667	245.57	2888.97	18255.19	199878.86	976.332	10690.008	19231.522	210568.868
665	27	17:00	30.859999	82.635000	468.816667	245.57	3134.54	18255.19	218134.05	976.332	11666.340	19231.522	229800.390
666	27	18:00	30.918333	82.628334	465.316667	252.00	3386.54	18255.19	236389.24	976.332	12642.672	19231.522	249031.912
667	27	19:00	30.880000	82.255000	464.433333	252.00	3638.54	18255.19	254644.43	976.332	13619.004	19231.522	268263.434
668	27	20:00	29.068333	82.506667	534.633333	126.00	3764.54	618.82	255263.25	33.096	13652.100	651.916	268915.350
669	27	21:00	28.246667	82.835000	563.433333	0.00	3764.54	0.00	255263.25	0.000	13652.100	0.000	268915.350
670	27	22:00	28.005000	82.850000	577.150000	126.00	3890.54	0.00	255263.25	0.000	13652.100	0.000	268915.350
671	27	23:00	27.868333	82.453333	588.616667	0.00	3890.54	0.00	255263.25	0.000	13652.100	0.000	268915.350

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample